1
What We Will Do Today
DSAI2202 Lab 1: PostgreSQL Setup and First Queries
00:00

Welcome to Lab 1

Today we install PostgreSQL on your own machine, meet pgAdmin 4, and run our first real SQL queries.

Today's checklist

  • Install PostgreSQL 16 and its companion tools
  • Meet pgAdmin 4, the graphical database client
  • Import a .sql file and run SQL
  • Find out where your schema physically lives

How the lab works

Each slide pairs a short explanation with a live code panel. Try every command yourself — do not just watch.

smoke_test.sql SQL
1
SELECT 1;
Expected result
 ?column?
--------
        1
(1 row)
🖼️ Gallery
What We Will Do Today